<?php


namespace App\Http\Controllers\android\model;


use Illuminate\Support\Facades\DB;

class TeacherSnModel
{
    public static function queryLeftAdminSn($where,$field){
        return DB::table('t_teacher_sn as t')
            ->leftJoin('t_admin_sn as a','t.admin_sn_id','=','a.id')
            ->leftJoin('t_batch as b','t.batch_id','=','b.id')
            ->where($where)
            ->first($field);
    }
}